TCustomDAConnection class overview.
Properties
  
    | Name |     Description |   
  
    | 
 ConnectDialog      | 
    
Allows to link a TCustomConnectDialog component. 
     | 
  
  
    | 
 ConnectString      | 
    
Used to specify the connection information, such as: UserName, Password, Server, etc. 
     | 
  
  
    | 
 ConvertEOL      | 
    
Allows customizing line breaks in string fields and parameters. 
     | 
  
  
    | 
 InTransaction      | 
    
Indicates whether the transaction is active. 
     | 
  
  
    | 
 LoginPrompt      | 
    
Specifies whether a login dialog appears immediately before opening a new connection. 
     | 
  
  
    | 
 Options      | 
    
Specifies the connection behavior. 
     | 
  
  
    | 
 Password      | 
    
Serves to supply a password for login. 
     | 
  
  
    | 
 Pooling      | 
    
Enables or disables using connection pool. 
     | 
  
  
    | 
 PoolingOptions      | 
    
Specifies the behaviour of connection pool. 
     | 
  
  
    | 
 Server      | 
    
Serves to supply the server name for login. 
     | 
  
  
    | 
 Username      | 
    
Used to supply a user name for login. 
     | 
  
Methods
  
    | Name |     Description |   
  
    | 
 ApplyUpdates      | 
    
Overloaded.
Applies changes in datasets. 
     | 
  
  
    | 
 Commit      | 
    
Commits current transaction. 
     | 
  
  
    | 
 Connect      | 
    
Establishes a connection to the server. 
     | 
  
  
    | 
 CreateSQL      | 
    
Creates a component for queries execution. 
     | 
  
  
    | 
 Disconnect      | 
    
Performs disconnect. 
     | 
  
  
    | 
 ExecProc      | 
    
Allows to execute stored procedure or function providing its name and parameters. 
     | 
  
  
    | 
 ExecProcEx      | 
    
Allows to execute a stored procedure or function. 
     | 
  
  
    | 
 ExecSQL      | 
    
Executes a SQL statement with parameters. 
     | 
  
  
    | 
 ExecSQLEx      | 
    
Executes any SQL statement outside the TQuery or TSQL components. 
     | 
  
  
    | 
 GetDatabaseNames      | 
    
Returns a database list from the server. 
     | 
  
  
    | 
 GetKeyFieldNames      | 
    
Provides a list of available key field names. 
     | 
  
  
    | 
 GetStoredProcNames      | 
    
Returns a list of stored procedures from the server. 
     | 
  
  
    | 
 GetTableNames      | 
    
Provides a list of available tables names. 
     | 
  
  
    | 
 MonitorMessage      | 
    
Sends a specified message through the TCustomDASQLMonitor component. 
     | 
  
  
    | 
 PerformConnect      | 
    
Establishes a connection to the server regardless of the LoginPrompt property. 
     | 
  
  
    | 
 Ping      | 
    
Used to check state of connection to the server. 
     | 
  
  
    | 
 Pooled      | 
    
Indicates whether the connection was retrieved from the pool or newly created. 
     | 
  
  
    | 
 RemoveFromPool      | 
    
Marks the connection that should not be returned to the pool after disconnect. 
     | 
  
  
    | 
 Rollback      | 
    
Discards all current data changes and ends transaction. 
     | 
  
  
    | 
 StartTransaction      | 
    
Begins a new user transaction. 
     | 
  
Events
  
    | Name |     Description |   
  
    | 
 OnConnectionLost      | 
    
This event occurs when connection was lost. 
     | 
  
  
    | 
 OnError      | 
    
This event occurs when an error has arisen in the connection. 
     |